CREATE TABLE BUILDING( 
 BUILDING_CODE DECIMAL(10) PRIMARY KEY NOT NULL,
 BUILDING_NAME VARCHAR (50),
 BUILDING_ADDRESS VARCHAR(50)
);

CREATE TABLE PATIENTS(
  PATIENT_ID DECIMAL(10) PRIMARY KEY NOT NULL,
  PAT_FIRST_NAME VARCHAR (50),
  PAT_LAST_NAME VARCHAR (50),  
  INSURANCE_PLAN_ID VARCHAR (50),
  CONTACT_NO VARCHAR (50)
);

CREATE TABLE PHYSICIAN( 
  PHYSICIAN_CODE DECIMAL(10) PRIMARY KEY NOT NULL,
  FIRST_NAME VARCHAR(50),
  LAST_NAME VARCHAR(50),
  CONTACT_NO VARCHAR(50),
  MAX_CAPACITY VARCHAR(50),
  BUILDING_CODE DECIMAL(10),
  SCHEDULE_ID DECIMAL(10),
);

CREATE TABLE INSURANCE_PLAN(
  INSURANCE_PLAN_ID VARCHAR(50) PRIMARY KEY NOT NULL,
  DESCRIPTION VARCHAR (50),
  PLAN_NAME VARCHAR (50),
);

CREATE TABLE PATIENT_VISIT(
  PATIENT_VISIT_ID DECIMAL(10) PRIMARY KEY NOT NULL,
  INSURANCE_PLAN_ID VARCHAR(50),
  PHYSICIAN_CODE DECIMAL(10),
  PATIENT_ID VARCHAR (50),
  PT_VISIT_DATE VARCHAR (50),
  SLOT_NO VARCHAR(50)
);

CREATE TABLE SCHEDULE(
 SCHEDULE_ID DECIMAL(10) PRIMARY KEY NOT NULL,
 PHYSICIAN_CODE DECIMAL(10),
 SLOT_NO VARCHAR (50),
 PATIENT_ID DECIMAL(10),
 WAITLIST_ID VARCHAR (50),
);

CREATE TABLE WAITLIST
(WAITLIST_ID VARCHAR (50) PRIMARY KEY NOT NULL,
 INSURANCE_PLAN_ID VARCHAR(50),
 PHYSICIAN_CODE DECIMAL(10),
 PATIENT_ID DECIMAL(10),
 PATIENT_VISIT_ID DECIMAL(10),
 SCHEDULE_ID DECIMAL(10),
 WTL_DATE VARCHAR(50),
 );